Re: Question on libpq parameters

At 11:45 PM -0500 11/29/08, Tom Lane wrote:
>Owen Hartnett <owen@clipboardinc.com> writes:
>>  The following libpq code chokes on me with invalid input to an
>>  integer parameter (state == PGRES_FATAL_ERR aPtr == "Error: Invalid
>>  Input syntax for integer """ .   It fails on the call to
>>  PQexecPrepared.  I suspect I'm not doing the parameters right.  Can
>>  anyone spot anything wrong?
>
>You can't just point to integers as if they were strings.  Didn't
>your compiler complain about that?
>
>            regards, tom lane

Yes, it did.  I'm confused.  My first parameter is a string, but the
following two are integers.  I thought the paramType parameter
indicated the type.  Do the integers need to be sprintf'd to strings?
There's only one paramValues array and it's type is a const char *
array.

-Owen